const connection = require('./baseDAO')

let sql = "SELECT u.*,r.role_name " +
    "FROM roledemo.user u\n" +
    "inner join role r\n" +
    "on u.role_id = r.role_id ";

function select(callback) {
    connection.query(sql,(err,rows)=> {
        callback(rows);
        // connection.end();
    })
}
function save(){}

module.exports = {
    select,
    save
}
